New worksheet previewed and printed without gridlines due to design.
Cause:
This behavior is by design of Excel 7.0. The behavior is different from the default behavior of the previous versions, where new worksheets were designed to be previewed and printed WITH gridlines. However, when workbooks or worksheets created in a previous version are opened in Excel 7.0, the files behave as they did in the previous version -- they are previewed and printed with gridlines.
Solution:
To print only one worksheet with gridlines, select the worksheet and select the 'Gridlines' check box in the 'Page Setup' dialog box before printing. To set up all worksheets in new workbooks to print with gridlines BY DEFAULT, create a workbook autotemplate with the 'Gridlines' option selected.
1) To print one worksheet with gridlines:
a) Click the tab for the worksheet to be printed. (The worksheet is selected.)
b) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
c) Click the 'Sheet' tab.
d) Select the 'Gridlines' check box in the 'Print' group.
the Gridlines check box
e) Click 'OK' to save the setting.
f) Click 'Print...'. (The Print dialog box appears.)
g) Click 'OK' to print the worksheet.
2) To set up all worksheets in new workbooks to print with gridlines:
a) Create a new, blank workbook:
1] Select the 'File' menu and select 'New...'. (The New dialog box appears.)
2] Select (click on) the 'Workbook' icon.
3] Click 'OK'. (A new, blank workbook appears.)
b) Select all the sheets in the new workbook:
1] Click the tab for the first worksheet.
2] Press and hold down SHIFT.
3] Click the tab for the last worksheet. (All the sheets are selected.)
c) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
d) Click the 'Sheet' tab.
e) Select the 'Gridlines' check box in the 'Print' group.
the Gridlines check box
f) Click 'OK' to save the setting.
g) Save the new workbook in the XLSTART folder and as a template:
1] Select the 'File' menu and select 'Save As...'. (The Save As dialog box appears.)
2] Select the drive where the Microsoft Office folder is located.
3] Select the Microsoft Office folder and click 'Open'.
4] Select the Excel folder and click 'Open'.
5] Select the XLSTART folder and click 'Open'.
6] Type BOOK as the name of the workbook in the 'File name' drop-down list box.
7] Select 'Template (*.XLT)' from the 'Save as type' drop-down list.
8] Click 'Save' to save the workbook.
h) Select the 'File' menu and select 'Exit' to close the workbook and exit Excel.
i) Restart Excel. (All new workbooks should now be set to print with gridlines.)
